package com.lanchetech.dao;
import java.math.BigDecimal;
import java.util.Date;

import com.lanchetech.bean.request.CommissionRecordPageReq;import com.lanchetech.entity.CommissionRecord;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface CommissionRecordMapper {
    int deleteByPrimaryKey(Long id);

    int insert(CommissionRecord record);

    int insertSelective(CommissionRecord record);

    CommissionRecord selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(CommissionRecord record);

    int updateByPrimaryKey(CommissionRecord record);

    int updateBatch(List<CommissionRecord> list);

    int updateBatchSelective(List<CommissionRecord> list);

    int batchInsert(@Param("list") List<CommissionRecord> list);

    List<CommissionRecord> findAllPage(CommissionRecordPageReq req);

    BigDecimal sumByStatusAndTime(@Param("status")Byte status, @Param("startTime")Date startTime, @Param("endTime")Date endTime);

    List<CommissionRecord> findAllByOrderSkuIds(@Param("orderSkuIds")List<Long> orderSkuIds);




}